Field Reference

Overview

Each stock in all_stocks_fundamental_analysis.json.gz contains 86 fields organized into 13 categories. Total Data Points: 2,775 stocks × 86 fields = 238,950 data points

1. Identity & Classification

Basic identification and sector information for each stock.

Symbol

string

required

Stock trading symbol (e.g., RELIANCE, TCS, INFY)

Name

string

Full company nameExample: "Reliance Industries Limited"

Listing Date

string

Date when the stock was first listed on NSEFormat: DD-MMM-YYYYExample: "29-Nov-1977"Source: NSE Archives CSV

Basic Industry

string

Granular industry classificationExample: "Refineries & Marketing"

Sector

string

Broad sector classificationExample: "Oil, Gas & Consumable Fuels"

Index

string

Comma-separated list of indices the stock is part ofExample: "NIFTY 50, NIFTY 100, NIFTY ENERGY"Value: "N/A" if not part of any tracked index

2. Fundamentals (Quarterly)

Quarterly financial metrics with sequential and year-over-year comparisons.

Quarter Identification

Latest Quarter

string

Identifier for the most recent reported quarterFormat: "Q3FY24", "Q4FY23"Example: "Q3FY25"

Net Profit (₹ Cr.)

Net Profit Latest Quarter

number

Net profit for the most recent quarter (in Crores)

Net Profit Previous Quarter

number

Net profit for Q-1

Net Profit 2 Quarters Back

number

Net profit for Q-2

Net Profit 3 Quarters Back

number

Net profit for Q-3

Net Profit Last Year Quarter

number

Net profit for the same quarter last year (for YoY comparison)

QoQ % Net Profit Latest

number

Quarter-over-Quarter percentage changeFormula: ((Latest - Previous) / |Previous|) × 100Example: 15.4 (15.4% growth)

YoY % Net Profit Latest

number

Year-over-Year percentage changeFormula: ((Latest - Last Year Quarter) / |Last Year Quarter|) × 100Example: 24.7 (24.7% growth)

Earnings Per Share (EPS)

Sales / Revenue (₹ Cr.)

Sales Latest Quarter

number

Revenue for the most recent quarter (in Crores)

Sales Previous Quarter

number

Revenue for Q-1

Sales 2 Quarters Back

number

Revenue for Q-2

Sales 3 Quarters Back

number

Revenue for Q-3

Sales Last Year Quarter

number

Revenue for the same quarter last year

QoQ % Sales Latest

number

Quarter-over-Quarter percentage change in revenue

YoY % Sales Latest

number

Year-over-Year percentage change in revenue

Sales Growth 5 Years(%)

number

Compound Annual Growth Rate (CAGR) over 5 yearsFormula: ((Current Annual Sales / Sales 5 Years Ago) ^ (1/5) - 1) × 100Example: 12.3 (12.3% CAGR)

Operating Profit Margin (OPM %)

OPM Latest Quarter

number

Operating profit margin for the most recent quarter

OPM Previous Quarter

number

OPM for Q-1

OPM 2 Quarters Back

number

OPM for Q-2

OPM 3 Quarters Back

number

OPM for Q-3

OPM Last Year Quarter

number

OPM for the same quarter last year

QoQ % OPM Latest

number

Quarter-over-Quarter percentage change in OPM

YoY % OPM Latest

number

Year-over-Year percentage change in OPM

OPM TTM(%)

number

Trailing Twelve Months (TTM) operating profit margin

3. Valuation Ratios

Key valuation and profitability metrics.

Market Cap(Cr.)

number

Market capitalization in Crores of RupeesExample: 150000.5 (₹1.5 Lakh Crore)

Stock Price(₹)

number

Current market price (Last Traded Price)Source: Live snapshot from Dhan APIExample: 2450.75

P/E

number

Price-to-Earnings ratioExample: 25.4Interpretation: Stock trades at 25.4× its annual earnings

Forward P/E

number

Forward Price-to-Earnings ratio (estimated based on latest quarter annualized)Formula: P/E × (TTM EPS / Annualized Latest Quarter EPS)Example: 22.1

Historical P/E 5

number

5-year average P/E ratioCurrent Status: 0.0 (not yet implemented)

PEG

number

Price/Earnings to Growth ratioFormula: P/E ÷ YoY EPS Growth %Example: 1.2Interpretation:

< 1: Potentially undervalued
= 1: Fairly valued
> 1: Potentially overvalued

ROE(%)

number

Return on EquityExample: 18.5 (18.5% ROE)

ROCE(%)

number

Return on Capital EmployedExample: 21.3 (21.3% ROCE)

D/E

number

Debt-to-Equity ratioFormula: Non-Current Liabilities ÷ Total EquityExample: 0.45Interpretation:

< 0.5: Conservative leverage
0.5-1.0: Moderate leverage
> 1.0: High leverage

4. Ownership & Float

Institutional ownership and free float data.

FII % change QoQ

number

Quarterly change in Foreign Institutional Investor holdingExample: 1.2 (FII holding increased by 1.2%)Negative values: FII selling

DII % change QoQ

number

Quarterly change in Domestic Institutional Investor holdingExample: -0.5 (DII holding decreased by 0.5%)

Free Float(%)

number

Percentage of shares available for public tradingFormula: 100 - Promoter Holding %Example: 45.2 (45.2% free float)

Float Shares(Cr.)

number

Number of shares in free float (in Crores)Formula: (Market Cap ÷ Stock Price) × (Free Float % ÷ 100)Example: 12.5 (12.5 Crore shares)

5. Technical Indicators

Technical analysis metrics and signals.

RSI (14)

number

14-period Relative Strength IndexRange: 0-100Interpretation:

< 30: Oversold
30-70: Neutral
> 70: Overbought

Example: 62.5

SMA Status

string

Position relative to key Simple Moving Averages with percentage distanceFormat: "SMA {period}: {Above|Below} ({percentage}%) | ..."Example: "SMA 20: Above (4.9%) | SMA 50: Above (24.1%)"Tracked SMAs: 20, 50, 200

EMA Status

string

Position relative to key Exponential Moving Averages with percentage distanceFormat: "EMA {period}: {Above|Below} ({percentage}%) | ..."Example: "EMA 20: Above (6.3%) | EMA 200: Above (72.6%)"Tracked EMAs: 20, 50, 200

Technical Sentiment

string

Summary of key technical indicatorsFormat: "RSI: {Neutral|Bullish|Bearish} | MACD: {Neutral|Bullish|Bearish}"Example: "RSI: Neutral | MACD: Bearish"

Pivot Point

string

Classic Pivot Point for the current sessionExample: "245.50"Value: "N/A" if not available

6. Price Performance

Historical returns and price ranges.

1 Day Returns(%)

number

Today’s percentage changeExample: 2.3 (up 2.3%)

1 Week Returns(%)

number

7-day percentage change

1 Month Returns(%)

number

30-day percentage change

3 Month Returns(%)

number

90-day percentage change

6 Month Returns(%)

number

6-month percentage change

1 Year Returns(%)

number

12-month percentage change

% from 52W High

number

Distance from 52-week highFormula: ((Current Price - 52W High) ÷ 52W High) × 100Example: -12.5 (12.5% below 52W high)Interpretation: Always negative or zero

% from 52W Low

number

Distance from 52-week lowExample: 45.2 (45.2% above 52W low)

% from ATH

number

Distance from All-Time HighRequires: ohlcv_data/ directoryExample: -25.3 (25.3% below ATH)

Gap Up %

number

Today’s opening gap percentageFormula: ((Today Open - Yesterday Close) ÷ Yesterday Close) × 100Example: 1.5 (1.5% gap up)Current Status: 0.0 (not yet implemented)

Day Range(%)

number

Intraday high-low spreadFormula: ((Day High - Day Low) ÷ Day Low) × 100Example: 3.2 (3.2% intraday range)

7. Volume & Liquidity

Volume metrics and liquidity indicators.

RVOL

number

Relative Volume (today’s volume vs 20-day average)Formula: Today's Volume ÷ 20-Day Average VolumeExample: 1.8 (80% higher than average)Interpretation:

< 1: Below average volume
= 1: Average volume
> 1: Above average volume

Requires: ohlcv_data/ directory

200 Days EMA Volume

number

200-day Exponential Moving Average of daily volumeRequires: ohlcv_data/ directory

% from 52W High 200 Days EMA Volume

number

Volume trend vs peak volume trendRequires: ohlcv_data/ directory

Daily Rupee Turnover 20(Cr.)

number

20-day average daily turnover in CroresFormula: Average(Price × Volume) over 20 days

Daily Rupee Turnover 50(Cr.)

number

50-day average daily turnover in Crores

Daily Rupee Turnover 100(Cr.)

number

100-day average daily turnover in Crores

30 Days Average Rupee Volume(Cr.)

number

30-day average daily turnover in Crores

8. Volatility

Average Daily Range (ADR) over different periods.

5 Days MA ADR(%)

number

5-day Moving Average of Average Daily RangeFormula: Average((Day High - Day Low) ÷ Day Low) × 100 over 5 daysRequires: ohlcv_data/ directory

14 Days MA ADR(%)

number

14-day Moving Average of Average Daily Range

20 Days MA ADR(%)

number

20-day Moving Average of Average Daily Range

30 Days MA ADR(%)

number

30-day Moving Average of Average Daily Range

Higher ADR = More volatile (larger intraday swings)Lower ADR = Less volatile (smaller intraday swings)

9. Circuit & Price Bands

Circuit Limit

string

Current circuit limit band percentagePossible Values: 2%, 5%, 10%, 20%Example: "20%"Source: NSE price bands data

10. Earnings Tracking

Post-earnings performance metrics.

Quarterly Results Date

string

Date of the latest financial results filingFormat: YYYY-MM-DDExample: "2024-11-08"Source: Company filings

Returns since Earnings(%)

number

Percentage change from pre-earnings close to current priceFormula: ((Current Price - Pre-Earnings Close) ÷ Pre-Earnings Close) × 100Example: 12.5 (12.5% gain since results)Requires: ohlcv_data/ + company_filings/

Max Returns since Earnings(%)

number

Peak percentage gain since results dayExample: 18.7 (peaked at 18.7% gain)Use Case: Identify if stock has already made its post-earnings move

11. Event Markers

Visual indicators for important corporate events and surveillance actions.

Event Markers

string

Pipe-separated list of event icons and descriptionsFormat: "{Icon}: {Description} | {Icon}: {Description}"Example: "📊: Results Recently Out | 💸: Dividend (15-Mar)"Value: "N/A" if no eventsSee Event Markers for full list of icons and triggers.

12. Recent Announcements (Regulatory)

Top 5 regulatory filings from company.

Recent Announcements

array

Array of regulatory filing objectsMax Items: 5Source: Hybrid from LODR + Legacy endpoints

[
  {
    "Date": "2024-11-08 14:30:00",
    "Headline": "Outcome of Board Meeting - Approval of Quarterly Results",
    "URL": "https://www.example.com/filing.pdf"
  }
]

Recent Announcements Item

object

Show properties

Date

string

Timestamp of the filingFormat: YYYY-MM-DD HH:MM:SS

Headline

string

Filing caption/headline (cleaned)

URL

string

Direct link to PDF filingValue: "N/A" if not available

13. News Feed (Media)

Top 5 real-time news items with AI sentiment analysis.

News Feed

array

Array of news objects with sentimentMax Items: 5Source: Dhan News API

[
  {
    "Title": "Company XYZ announces expansion plans",
    "Sentiment": "positive",
    "Date": 1699459200
  }
]

News Feed Item

object

Show properties

Title

string

News headline

Sentiment

string

AI-analyzed sentimentPossible Values: "positive", "negative", "neutral"

Date

number

Unix timestamp of publicationExample: 1699459200

Field Type Summary

Type	Count	Examples
String	12	Symbol, Name, Latest Quarter, SMA Status
Number (Financial)	45	Net Profit, EPS, Sales, OPM (all quarters + changes)
Number (Valuation)	9	Market Cap, P/E, ROE, ROCE, D/E
Number (Technical)	13	RSI, Returns, % from 52W High, ADR
Number (Volume)	5	RVOL, Turnover (various periods)
Array	2	Recent Announcements, News Feed
Total	86

Example Stock Object

{
  "Symbol": "RELIANCE",
  "Name": "Reliance Industries Limited",
  "Listing Date": "29-Nov-1977",
  "Basic Industry": "Refineries & Marketing",
  "Sector": "Oil, Gas & Consumable Fuels",
  "Market Cap(Cr.)": 1650000.0,
  "Latest Quarter": "Q3FY25",
  "Net Profit Latest Quarter": 16500.0,
  "QoQ % Net Profit Latest": 5.2,
  "YoY % Net Profit Latest": 12.8,
  "Stock Price(₹)": 2450.75,
  "P/E": 25.4,
  "ROE(%)": 14.2,
  "RSI (14)": 62.5,
  "1 Month Returns(%)": 8.3,
  "Event Markers": "📊: Results Recently Out | 💸: Dividend (15-Mar)",
  "Recent Announcements": [
    {
      "Date": "2024-11-08 14:30:00",
      "Headline": "Outcome of Board Meeting",
      "URL": "https://example.com/filing.pdf"
    }
  ],
  "News Feed": [
    {
      "Title": "Reliance announces new venture",
      "Sentiment": "positive",
      "Date": 1699459200
    }
  ]
}

Output Data

API Endpoints

Overview

1. Identity & Classification

2. Fundamentals (Quarterly)

3. Valuation Ratios

4. Ownership & Float

5. Technical Indicators

6. Price Performance

7. Volume & Liquidity

8. Volatility

9. Circuit & Price Bands

10. Earnings Tracking

11. Event Markers

12. Recent Announcements (Regulatory)

13. News Feed (Media)

Field Type Summary

Example Stock Object

Output Data

API Endpoints

​Overview

​1. Identity & Classification

​2. Fundamentals (Quarterly)

​3. Valuation Ratios

​4. Ownership & Float

​5. Technical Indicators

​6. Price Performance

​7. Volume & Liquidity

​8. Volatility

​9. Circuit & Price Bands

​10. Earnings Tracking

​11. Event Markers

​12. Recent Announcements (Regulatory)

​13. News Feed (Media)

​Field Type Summary

​Example Stock Object

Overview

1. Identity & Classification

2. Fundamentals (Quarterly)

3. Valuation Ratios

4. Ownership & Float

5. Technical Indicators

6. Price Performance

7. Volume & Liquidity

8. Volatility

9. Circuit & Price Bands

10. Earnings Tracking

11. Event Markers

12. Recent Announcements (Regulatory)

13. News Feed (Media)

Field Type Summary

Example Stock Object